﻿

CREATE PROCEDURE [dbo].[proc_ConsumableList_Update]
(
	@ConsumableName NVARCHAR(100),
	@ConsumableAllMonth INT	,
	@id INT,
	@UserId VARCHAR(20),
	@UserName NVARCHAR(20),
	@LrDate DATETIME
)
AS 
BEGIN
UPDATE [ConsumableList]
   SET [ConsumableName] = @ConsumableName
      ,[ConsumableAllMonth] = @ConsumableAllMonth
      ,userid=@UserId
      ,username=@UserName
      ,lrdate=@LrDate
 WHERE [id]=@id


END
RETURN

